﻿


alter PROCEDURE [PomAddressSelectByAddressID]
(
	@pAddressID INT
)

AS
BEGIN	
	SET NOCOUNT ON;
	SELECT a.PomplingAddressID, a.AddressLine1, a.AddressLine2, a.City, a.County, a.Postcode, 
		a.DateAdded
		FROM [PomPomplingAddresses] a
		WHERE a.PomplingAddressID = @pAddressID
END